select 
     b.region_name || '-' || a.region_name as description
     ,a.ldcode || seq_account.nextval as  id
     ,a.ldcode
     ,a.postcode
 from 
     t_region a,
     t_region b
 where 
    a.pid=b.tuid 
and 
    b.pid is null
and 
    a.ldcode like ${fld:userlogin} 